﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace QuanLyBanHang.DAL
{
    public class NhaCungCap_DAL
    {
        dbConnection conn;
        public NhaCungCap_DAL()
        {
            conn = new dbConnection();
        }
        //public DataTable Select(string key)
        //{
        //    string query = "select * from NHACUNGCAP where TenNCC like '%'+@ten+'%'";
        //    SqlParameter[] p = new SqlParameter[1];
        //    p[0] = new SqlParameter("@ten", key);
        //    return conn.execSelectQuery(query, p);
        //}
        //public bool insert(string ten, string dc, string sodt, string email)
        //{
        //    string query = "insert into NHACUNGCAP values(@ten,@dc,@sodt,@email)";
        //    SqlParameter[] p = new SqlParameter[4];
        //    p[0] = new SqlParameter("@ten", ten);
        //    p[1] = new SqlParameter("@dc", dc);
        //    p[2] = new SqlParameter("@email", email);
        //    p[3] = new SqlParameter("@sodt", sodt);
        //    return conn.execInsertQuery(query, p);
        //}
    }
}
